/*
 * Copyright 2013 JROSE
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.jrose.core.jdbc;

import lombok.Getter;
import org.jrose.core.jdbc.datasource.RoutingPolicySupportedTransactionManager;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.support.TransactionTemplate;

import javax.sql.DataSource;

/**
 * Database connection holder for providing all necessaries to access database.
 *
 * @author Xiaohai Zhang
 * @since 2013-08-21 22:07
 */
public class DatabaseConnection {
    @Getter private final DataSource dataSource;
    @Getter private final JdbcTemplate jdbcTemplate;
    @Getter private final NamedParameterJdbcTemplate namedParameterJdbcTemplate;
    @Getter private final PlatformTransactionManager transactionManager;
    @Getter private final TransactionTemplate transactionTemplate;

    public DatabaseConnection(DataSource dataSource) {
        if (dataSource == null) {
            throw new IllegalArgumentException("DataSource must not be null");
        }
        this.dataSource = dataSource;

        this.jdbcTemplate = new JdbcTemplate(this.dataSource);
        this.jdbcTemplate.afterPropertiesSet();

        this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(this.jdbcTemplate);

        this.transactionManager = new RoutingPolicySupportedTransactionManager();
        ((RoutingPolicySupportedTransactionManager) this.transactionManager).setDataSource(this.dataSource);
        ((RoutingPolicySupportedTransactionManager) this.transactionManager).afterPropertiesSet();

        this.transactionTemplate = new TransactionTemplate(this.transactionManager);
        this.transactionTemplate.afterPropertiesSet();
    }
}
